﻿CREATE PROCEDURE dbo.SP_Members_UPDATE
												@Birthdate DateTime 							  =  NULL 
														, @ConfessionFather NChar 							(10)  =  NULL 
														, @CountryId Int 							  =  NULL 
														, @CreationDate DateTime 							  =  NULL 
														, @DisplayName NVarChar 							(256)  =  NULL 
														, @Email NVarChar 							(256)  =  NULL 
														, @FirstName NVarChar 							(256)  =  NULL 
														, @Gender TinyInt 							  =  NULL 
														, @ImagePath NVarChar 							(50)  =  NULL 
														, @IsActive Bit 							  =  NULL 
														, @LastName NVarChar 							(256)  =  NULL 
														, @LastUpdateDate DateTime 							  =  NULL 
														, @MemberId Int 							  =  NULL 
														, @NationalityId Int 							  =  NULL 
														, @Password NVarChar 							(500)  =  NULL 
												AS
					UPDATE Members SET
													Birthdate=@Birthdate 
																,ConfessionFather=@ConfessionFather
																,CountryId=@CountryId
																,CreationDate=@CreationDate
																,DisplayName=@DisplayName
																,Email=@Email
																,FirstName=@FirstName
																,Gender=@Gender
																,ImagePath=@ImagePath
																,IsActive=@IsActive
																,LastName=@LastName
																,LastUpdateDate=@LastUpdateDate
																,NationalityId=@NationalityId
																,Password=@Password
													Where 	
												MemberId=@MemberId
							